
DROP TABLE IF EXISTS "SysEmployee";
CREATE TABLE "SysEmployee" (
  "EId" integer NOT NULL,
  "UserName" varchar(50),
  "RealName" varchar(50),
  "Password" varchar(50),
  "Status" integer,
   "Age" INTEGER,
  "EIcon" varchar(50),
  "Phone" varchar(50),
  "Mobile" varchar(50),
  "Address" varchar(50),
  "Email" varchar(50),
  "QQ" varchar(50),
  "WeChat" varchar(50),
  "Gender" integer,
  "LastLoginTime" varchar(50),
  "CreateTime" varchar(50),
  "CreateId" INTEGER,
  "LastModifyTime" varchar(50),
  "LastModifyId" INTEGER,
  PRIMARY KEY ("EId")
);

INSERT [dbo].[SysEmployee] ( [EId], [UserName], [RealName],[Password], [Status],[Age], [EIcon], [Phone], [Mobile], [Address], [Email], [QQ], [WeChat], [Gender], [LastLoginTime], [CreateTime], [CreateId], [LastModifyTime], [LastModifyId]) VALUES ( 2024001,N'admin',N'Administrator',  N'123456', 1,30, N'a01.jpg', NULL, NULL, N'AAAAAA2', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL);

INSERT [dbo].[SysEmployee] ([EId], [UserName], [RealName],[Password], [Status],[Age], [EIcon], [Phone], [Mobile], [Address], [Email], [QQ], [WeChat], [Gender], [LastLoginTime], [CreateTime], [CreateId], [LastModifyTime], [LastModifyId]) VALUES ( 2024002,N'jovan',N'Jovan Cheng',  N'123456', 1,30, N'a02.jpg', NULL, NULL, N'湖北省武汉市汉阳区人信大厦', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL);

INSERT [dbo].[SysEmployee] ( [EId], [UserName], [RealName],[Password], [Status],[Age], [EIcon], [Phone], [Mobile], [Address], [Email], [QQ], [WeChat], [Gender], [LastLoginTime], [CreateTime], [CreateId], [LastModifyTime], [LastModifyId]) VALUES ( 2024003,N'gabby',N'Gabby',  N'123456', 1,30, N'a03.jpg', NULL, NULL, N'AAAAAA2', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL);

INSERT [dbo].[SysEmployee] ( [EId], [UserName], [RealName],[Password], [Status],[Age], [EIcon], [Phone], [Mobile], [Address], [Email], [QQ], [WeChat], [Gender], [LastLoginTime], [CreateTime], [CreateId], [LastModifyTime], [LastModifyId]) VALUES ( 2024004,N'test',N'Test',  N'123456', 1,30, N'a04.jpg', NULL, NULL, N'AAAAAA2', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL);
